Why use a query?

Query files provide a means of off-loading much of the data-generating tasks normally performed by Seagate Crystal Reports to the database server. The set of data returned represents a subset of the actual data in the database - only the data you specifically need.

If you are an experienced SQL programmer, the Crystal SQL Designer enables you to reuse your existing queries, quickly and easily. All of your existing queries become convenient query files that you can use to design reports with Seagate Crystal Reports.

Although Seagate Crystal Reports supports powerful SQL pass-through reporting, it does not support the full SQL language or allow you to edit every part of an SQL statement. By using the Crystal SQL Designer, you are able to use all of the power of SQL, including complex joins, sorts, and aggregate functions. In addition, a query file provides full ANSI SQL compatibility.